create procedure [dbo].[BAECartEventGetForUserByEventCode] @UserId varchar(32),
     @EventCode varchar(64),
     @RegId varchar(32) as
SELECT *
    FROM CartEvent ce
    INNER JOIN CartItem ci on ci.CartItemID = ce.CartItemID
    WHERE ci.UserID = @UserId
        AND ce.EventCode = @EventCode
        AND ce.RegistrantID = @RegId

GO